package com.anolesoft.yr.mbus.prod.pack.sql;

public class ProdPackageServiceValueSQL {

    //新增产品套餐服务项参数信息表
    public static final String SAVE_PROD_PACKAGE_SERVICE_VALUE = "insert into prod_package_service_value(objuid,fac_code,prod_package_uid,prod_package_service_uid,prod_service_value_uid,value,is_default,is_holiday,accept_time,reply_time,delivery_time,arrival_time) values(#{objuid},#{facCode},#{prodPackageUid},#{prodPackageServiceUid},#{prodServiceValueUid},#{value},#{isDefault},#{isHoliday},#{acceptTime},#{replyTime},#{deliveryTime},#{arrivalTime})";

    //修改产品套餐服务项参数信息表
    public static final String UPDATE_PROD_PACKAGE_SERVICE_VALUE = "update prod_package_service_value a set a.prod_service_value_uid=#{prodServiceValueUid},a.value=#{value},a.is_default=#{isDefault},a.is_holiday=#{isHoliday},a.accept_time=#{acceptTime},a.reply_time=#{replyTime},a.delivery_time=#{deliveryTime},a.arrival_time=#{arrivalTime} where a.objuid=#{objuid}";

    //修改产品套餐服务项参数信息表
    public static final String DELETE_PROD_PACKAGE_SERVICE_VALUE = "<script> delete from prod_package_service_value where prod_package_uid=#{prodPackageUid} and prod_package_service_uid not in <foreach collection='prodPackageServiceDeleteDTOList' open='(' item='prodPackageService' separator=',' close=')'> #{prodPackageService.objuid}</foreach> </script>";

    //根据主键查询产品套餐服务项参数唯一数据
    public static final String QUERY_PROD_PACKAGE_SERVICE_VALUE_BY_UID = "select a.* from prod_package_service_value a where a.prod_package_uid=#{objuid} and a.prod_package_service_uid=#{prodPackageServiceUid}";

}
